﻿CREATE TABLE [dbo].[Student]
(
	[ID] INT NOT NULL PRIMARY KEY IDENTITY, 
    [MemberID] INT NOT NULL, 
    [DepartmentId] INT NOT NULL, 
    CONSTRAINT [FK_Student_ToMembers] FOREIGN KEY ([MemberID]) REFERENCES [Members]([Id]), 
    CONSTRAINT [FK_Student_DepartmentId] FOREIGN KEY ([DepartmentId]) REFERENCES [Department]([Id])
)
